home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Visual Database / Visual dBase v5.5 / SAMPLES2.PAK / EQUIPMNT.QBE < prev    next >
Encoding:
Text File  |  1995-07-18  |  365 b   |  17 lines
  1. * dBASE Windows .QBE file 9
  2. CLOSE DATABASES
  3. SET EXACT ON
  4. SELECT 1
  5. USE FLIGHTS.DBF ORDER FLIGHT_NO
  6. SELECT 2
  7. USE AIRCRDB.DBF ORDER TAG AIRCRAFT
  8. SELECT 1
  9. SET RELATION TO AIRCRAFT INTO AIRCRDB
  10. SET FILTER TO FOUND(2)
  11. SET FIELDS TO FLIGHT_NO, ORIGIN, DEST, AIRCRAFT, DEPARTURE, ARRIVAL, DATE,;
  12. PRICE
  13. SELECT 2
  14. SET FIELDS TO AIRCRAFT, IMAGE
  15. SELECT 1
  16. GO TOP
  17.